package cn.com.xiaoshoujia.user.mapper;

import cn.com.xiaoshoujia.user.entity.ShareUser;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

public interface ShareUserMapper {

    @Select({"SELECT id, " +
                "phone, " +
                "share_name, " +
                "sex, " +
                "address, " +
                "city, " +
                "province, " +
                "country, " +
                "img_url, " +
                "unionid," +
                "sys_id," +
                "sys_type, " +
                "CREATE_TIME, " +
                "yn " +
                "FROM " +
            "sls_bn_share_user " +
            "WHERE sys_id = #{sysId}"})
    @Results({
            @Result(property = "id",column = "id",id = true),
            @Result(property = "phone",column = "phone"),
            @Result(property = "shareName",column = "share_name"),
            @Result(property = "imgUrl",column = "img_url"),
            @Result(property = "yn",column = "yn")
    })
    ShareUser getBySysId(String sysId);

}
